-- Script to create EPOMS database and it's tables (with attributes)


--  Step 1: Create EPOMS Database

create database epoms;


-- Step 2: Use EPOMS Database

use epoms;


-- Step 3: Create AccountValidation Table

CREATE TABLE AccountValidation (username VARCHAR(100) NOT NULL PRIMARY KEY,password VARCHAR(100)  NOT NULL ,firstname VARCHAR(100)  NOT NULL ,lastname VARCHAR(100) NOT NULL );


-- Step 4: Create ProductOwnership Table

create table ProductOwnership (username varchar(100) not null primary key, productname varchar(100) not null, backupfirstname varchar (100)  not null, backuplastname varchar(100) not null);


-- Step 5: Create VacationManager Table (Multiple Primary Keys)

create table VacationManager(username varchar(100) not null, startdate varchar(100) not null, enddate varchar(100)  not null, PRIMARY KEY (username , startdate, enddate  ));

   
